Access to database files must be limited to relevant processes and to authorized, administrative users.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-68967	PPS9-00-006100	SV-83571r1_rule		Medium

Description
Applications, including DBMSs, must prevent unauthorized and unintended information transfer via shared system resources. Permitting only DBMS processes and authorized, administrative users to have access to the files where the database resides helps ensure that those files are not shared inappropriately and are not open to backdoor access and manipulation.

STIG	Date
EDB Postgres Advanced Server Security Technical Implementation Guide	2020-03-06

Details

Check Text ( C-69439r1_chk )
Verify User ownership, Group ownership, and permissions on the directory: > ls –ald If the User owner is not “enterprisedb”, this is a finding If the Group owner is not “enterprisedb”, this is a finding. If the directory is more permissive than 700, this is a finding. (The default path for the postgresql data directory is /var/lib/ppas/9.5/data, but this will vary according to local circumstances.)

Check Text ( C-69439r1_chk )

Verify User ownership, Group ownership, and permissions on the directory:
> ls –ald
If the User owner is not “enterprisedb”, this is a finding
If the Group owner is not “enterprisedb”, this is a finding.
If the directory is more permissive than 700, this is a finding.

(The default path for the postgresql data directory is /var/lib/ppas/9.5/data, but this will vary according to local circumstances.)

Fix Text (F-75151r1_fix)
Run these commands: 1) "chown enterprisedb " 2) "chgrp enterprisedb " 3) "chmod 700 " (The default path for the postgresql data directory is /var/lib/ppas/9.5/data, but this will vary according to local circumstances.)